PlStudentSearchAgent 
Logical Entity Name  PlStudentSearchAgent 
Default Table Name  PlStudentSearchAgent 
Physical Only  NO 
Definition 
 
Note 
 

PlStudentSearchAgent Columns 
ColumnName  Domain  Datatype  NULL  Definition 
PlStudentSearchAgentID(PK)    int  NO 
 
Agent_Name    varchar(100)  NO 
 
SyStudentID(FK)    int  NO 
 
PlJobType    varchar(8000)  YES 
 
PlJobTitleID(FK)    int  YES 
 
PlIndustryID(FK)    int  YES 
 
PlJobCategoryID(FK)    int  NO 
 
Keywords    varchar(100)  YES 
 
Schedule    char(1)  NO 
 
PlLocationID(FK)    int  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
JobAge    int  NO 
 
IsScheduled    bit  NO 
 
FrequencyCode    char(1)  YES 
 
IncludeOnlyNewJobs    bit  NO 
 
LastRun    datetime  YES 
 
EvaluateAllCriteria    bit  NO 
 

PlStudentSearchAgent Primary and Unique Keys 
Key Name  Key Type  Keys 
PlStudentSearchAgent_SyStudentID_Agent_Name_U_N_IDX  Index  SyStudentID, Agent_Name 
PlStudentSearchAgent_PlStudentSearchAgentID_U_C_IDX  PrimaryKey  PlStudentSearchAgentID 

PlStudentSearchAgent Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
PlIndustry  Non-Identifying  Zero or One to Zero or More  FK_PlStudentSearchAgent_PlIndustryID_PlIndustry_PlIndustryID      PlIndustryID  NO  YES 
PlJobCategory  Non-Identifying  One To Zero or More  FK_PlStudentSearchAgent_PlJobCategoryID_PlJobCategory_PlJobCategoryID      PlJobCategoryID  NO  YES 
PlJobTitle  Non-Identifying  Zero or One to Zero or More  FK_PlStudentSearchAgent_PlJobTitleID_PlJobTitle_PlJobTitleID      PlJobTitleID  NO  YES 
PlLocation  Non-Identifying  Zero or One to Zero or More  FK_PlStudentSearchAgent_PlLocationID_PlLocation_PlLocationID      PlLocationID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_PlStudentSearchAgent_SyStudentID_SyStudent_SyStudentID      SyStudentID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_PlStudentSearchAgent_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
PlStudentSearchAgentSchedule  Non-Identifying  One To Zero or More  FK_PlStudentSearchAgentSchedule.PlStudentSearchAgentScheduleID_PlStudentSearchAgent.PlStudentSearchAgentID        NO  YES 
PlStudentSearchAgentSkills  Identifying  One To Zero or More  FK_PlStudentSearchAgentSkills_PlStudentSearchAgentID_PlStudentSearchAgent_PlStudentSearchAgentID        NO  YES 

PlStudentSearchAgent Check Constraints 
Check Constraint Name  CheckConstraint